import pandas as pd
df = pd.read_csv("20170930.csv",
                 dtype={
                     "ticker": str,
                     "holdingTicker": str,
                 },
                 encoding='GBK')
# print(df[['ticker', 'holdingTicker', 'marketValue', 'industryName1']].head())
# print(df[['ticker', 'holdingTicker', 'marketValue', 'industryName1']])
# print(df['ticker'].head())
# print(df[['ticker']].head())
# print(df[["holdingTicker"]].groupby(df['ticker']).count())
print(df[["holdingTicker"]].groupby(df['industryName1']).count())
